﻿--================================--
-- USER

IF NOT EXISTS (SELECT * FROM [User] WHERE UserRoleId = 1)
BEGIN
	declare @superAdminRoleId INTEGER;
	declare @adminRoleId INTEGER;
	SET @superAdminRoleId = 1
	SET @adminRoleId = 2
	INSERT INTO [User] (Name, [Password], Title, UserRoleId) VALUES ('SuperUser', 's3cr3t!', 'Trùm', @superAdminRoleId);
	INSERT INTO [User] (Name, [Password], Title, UserRoleId) VALUES ('Azun', 'Azun', 'Dev', @adminRoleId);
	INSERT INTO [User] (Name, [Password], Title, UserRoleId) VALUES ('Toan', 'Toan', 'Dev', @adminRoleId);
	INSERT INTO [User] (Name, [Password], Title, UserRoleId) VALUES ('Nam', 'Nam', 'Dev', @adminRoleId);
	INSERT INTO [User] (Name, [Password], Title, UserRoleId) VALUES ('Nhat', 'Nhat', 'Dev', @adminRoleId);
END

--================================--
-- ORDER TABLE
IF NOT EXISTS (SELECT * FROM OrderTable WHERE Name = '01')
BEGIN
INSERT INTO OrderTable (Name) VALUES ('01');
INSERT INTO OrderTable (Name) VALUES ('02');
INSERT INTO OrderTable (Name) VALUES ('03');
INSERT INTO OrderTable (Name) VALUES ('04');
INSERT INTO OrderTable (Name) VALUES ('05');
INSERT INTO OrderTable (Name) VALUES ('06');
INSERT INTO OrderTable (Name) VALUES ('07');
INSERT INTO OrderTable (Name) VALUES ('08');
INSERT INTO OrderTable (Name) VALUES ('09');
INSERT INTO OrderTable (Name) VALUES ('10');
INSERT INTO OrderTable (Name) VALUES ('11');
INSERT INTO OrderTable (Name) VALUES ('12');
INSERT INTO OrderTable (Name) VALUES ('13');
INSERT INTO OrderTable (Name) VALUES ('14');
INSERT INTO OrderTable (Name) VALUES ('15');
INSERT INTO OrderTable (Name) VALUES ('16');
INSERT INTO OrderTable (Name) VALUES ('17');
INSERT INTO OrderTable (Name) VALUES ('18');
INSERT INTO OrderTable (Name) VALUES ('19');
INSERT INTO OrderTable (Name) VALUES ('20');
INSERT INTO OrderTable (Name) VALUES ('21');
INSERT INTO OrderTable (Name) VALUES ('22');
INSERT INTO OrderTable (Name) VALUES ('23');
INSERT INTO OrderTable (Name) VALUES ('24');
INSERT INTO OrderTable (Name) VALUES ('25');
INSERT INTO OrderTable (Name) VALUES ('26');
INSERT INTO OrderTable (Name) VALUES ('27');
INSERT INTO OrderTable (Name) VALUES ('28');
INSERT INTO OrderTable (Name) VALUES ('29');
INSERT INTO OrderTable (Name) VALUES ('30');
INSERT INTO OrderTable (Name) VALUES ('31');
INSERT INTO OrderTable (Name) VALUES ('32');
INSERT INTO OrderTable (Name) VALUES ('33');
INSERT INTO OrderTable (Name) VALUES ('34');
INSERT INTO OrderTable (Name) VALUES ('35');
INSERT INTO OrderTable (Name) VALUES ('36');
INSERT INTO OrderTable (Name) VALUES ('37');
INSERT INTO OrderTable (Name) VALUES ('38');
INSERT INTO OrderTable (Name) VALUES ('39');
END

